-
i have two table input_table +——–+———–+————+ | id | id_user | input_date | +——–+———–+————+ | 1 | A | 2020-09-18 …
- 407 views
- 1 answers
- 0 votes
-
I have a database with 2 columns. character_id and killmail_id The object is to get a list of all killmail_ids …
- 369 views
- 1 answers
- 0 votes
-
I have two query that I would like to combine into one. Query 1: SELECT Quantity FROM Table1 WHERE IdProduct …
- 438 views
- 5 answers
- 0 votes
-
I’m trying to update all the positions where the value is equal to 0, so I’m trying to get the …
- 370 views
- 1 answers
- 0 votes
-
This question already has answers here: SQL: Group by minimum value in one field while selecting distinct rows (8 answers) …
- 421 views
- 2 answers
- 0 votes
-
I know this question might sound confusing. Let me use an example to illustrate. Say right now I have 4 …
- 404 views
- 1 answers
- 0 votes
-
I want to query over a query to find unmatched id’s. I have a list of ID’s and I want …
- 362 views
- 2 answers
- 0 votes
-
I was having trouble with this Update Table Set ‘Contains’=(Select Group_Concat(T1.FieldX) from Table T1 Inner Join Table T2 on T1.FieldA=T2.FieldA …
- 368 views
- 0 answers
- 0 votes
-
Anyone could explain me which query is more performant and which is the difference behind the scene? SELECT PRODUCT.id, SUM(PRODUCTION.quantity) …
- 376 views
- 2 answers
- 0 votes
-
I have 2 tables. dance_list – table name type_of_dance – column name (only has 1 column) motion_list – table name …
- 389 views
- 1 answers
- 0 votes